Release 10.1A: OpenEdge Data Management:
SQL Development

Progress 4GL and OpenEdge SQL interaction in an OpenEdge application

In an OpenEdge application, data management can be controlled by the Progress 4GL programming language, the OpenEdge SQL language, or both. This section provides details on the relationship between the languages. Specifically, this section covers the following topics:

Comparing Progress 4GL and OpenEdge SQL
Understanding OpenEdge SQL database structure
Comparing OpenEdge SQL and Progress 4GL database objects
Naming objects for OpenEdge SQL and Progress 4GL databases
Working with data type compatibility
Working with SQL column widths
Working with triggers
Working with locking behavior and isolation levels